use InOut

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"